package link.wangkui.learn.boot.excel;


import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;

import java.util.List;
import java.util.Map;

public class ExcelUtils {
    public static void main(String[] args) {
//        ExcelReader reader = ExcelUtil.getReader("C:\\Users\\王魁\\Desktop\\乐信老年人评估\\仲恺区\\老年人能力评估.xlsx");
        ExcelReader reader = ExcelUtil.getReader("C:\\Users\\王魁\\Desktop\\乐信老年人评估\\仲恺区\\excels\\陈江.xlsx");
        List<Map<String,Object>> readAll = reader.readAll();
        for (int i=0;i<readAll.size();i++) {
            readAll.get(i).keySet().forEach(System.out::print);
            System.out.println();
        }
        for (int i=0;i<readAll.size();i++) {
            readAll.get(i).values().forEach(System.out::print);
            System.out.println();
        }
    }
}
